Stored Procedures [dbo].[BAEEventSetupGetQuestions]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@eventCodevarchar(16)16
SQL Script
create procedure [dbo].[BAEEventSetupGetQuestions] @eventCode varchar(16) as
SELECT *,
         UPPER(FunctionCode) + '      ' + Question EventQuestion
    FROM EventSetupQuestion
    WHERE EventCode = @eventCode
    ORDER BY QuestionOrder

GO
Uses